{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Device-A","ROC Curve"],"not_rendered":{"charts":2,"comments":2},"unopened":[{"sheet":"ROC Curve","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Device-A","index":0,"n_rows":33,"n_cols":63,"rows_kept":33}
["v1.01","ABCD 2021 AAPOS Validation Assistant",{"$nulls":9},"-Esotropia","RETINOSCOPY",{"$nulls":8}," >3","age<4",{"$nulls":3},"<2 D"," >3 D",{"$nulls":7},"Autorefractor",{"$nulls":10},"sensitive",null," <-2",1.75," >3",1.5,2.25,1.5,2.5,1]
[{"$nulls":9},"Visual acuity",null,"+Exotropia","X = Exam",{"$nulls":8}," >1.75","age≥4",{"$nulls":3}," <3 D"," >1.75 D",{"$nulls":14},"refer",{"$nulls":3},"regular",null," <-3",2," >3.5",1.75,2.75,1.75,3,1.25]
[{"$nulls":9},"c s m is centered steady maintained fixation",{"$nulls":14},"∆merid-myopia",{"$nulls":4},"Are Risk Factors Present?",{"$nulls":5},"sphere","cylinder","axis",{"$nulls":4},"pass",{"$nulls":3},"specific",null," <-3.5",2.5," >4.25",2.25,3,2.25,3.5,1.75]
[{"$nulls":42},"inconcl",{"$nulls":13},"Age-based"]
[null,"Series","order","Age","Gender","First","Last","BD","Exam date","VaR","VaL","Tropia","SphR","CylR","AxisR","SphL","CylL","axisL","XRsp","xLsp","xaniso","xmax cyl","meridM","meridH","merAni","agegroup <4y?","cutoff-M","cutoff-Cyl","Hyperopa?","Anisometropia?","Astigmatism?","Myopia?","Strabismus?","refract. ARF?","ARF?","a-SpR","a-CylR","a-axR","a-SpL","a-CylL","a-axL","Align?","?refer?","Refract Valid","Valid 2x2","use these to build ROC --->","aSphEqr","aSphEql","myom3","myom2","hypmerid","anismerid","cyl3max","cyl1.7max","hmax","anisoSEq","ROC build -->","PxSp<4","PxRef<4","PxSen<4","PxSp>4","PxRef>4","PxSen>4"]
[null,"Device-A",1,{"$f":"(I6-H6)/365.24","v":{"v":8.45745263388457,"d":"8.5"}},"m","Donald","Duck","2004-07-21","2013-01-04",20,400,-15,0.25,0,0,-2.5,0.25,75,{"$f":"M6+N6/2","v":0.25},{"$f":"P6+Q6/2","v":-2.375},{"$f":"ABS(S6-T6)","v":2.625},{"$f":"MAX(N6,Q6)","v":0.25},{"$f":"MIN((S6-ABS(N6/2)),(T6-ABS(Q6/2)))","v":-2.5},{"$f":"MAX((S6+ABS(N6/22)),(T6+ABS(Q6/2)))","v":0.25},{"$f":"ABS((S6-ABS(N6/2))-(T6-ABS(Q6/2)))","v":2.75},{"$f":"IF(D6<4,\"preschool\",\"school\")","v":"school"},{"$f":"IF(D6<4,-3,-2)","v":-2},{"$f":"IF(D6<4,3,1.75)","v":1.75},{"$f":"IF(X6>4,\"T\",\"F\")","v":"F"},{"$f":"IF(Y6>1.25, \"T\",\"F\")","v":"T"},{"$f":"IF(V6>AB6,\"T\",\"F\")","v":"F"},{"$f":"IF(W6<AA6,\"T\",\"F\")","v":"T"},{"$f":"IF(ABS(L6)>8,\"T\",\"F\")","v":"T"},{"$f":"IF(OR(EXACT(\"T\",AC6:AF6)),\"T\",\"F\")","v":"T"},{"$f":"OR(EXACT(\"T\",AC6:AG6))","v":true},0.75,0.25,100,-0.5,0.5,90,"r","refer",{"$f":"IF(AND(AH6=\"T\",AQ6=\"refer\"),\"A\",IF(AND(AH6=\"T\",AQ6=\"pass\"),\"C\",IF(AND(AH6=\"F\",AQ6=\"refer\"),\"B\",\"D\")))","v":"A"},{"$f":"IF(AND(AI6=TRUE,AQ6=\"refer\"),\"A\",IF(AND(AI6=TRUE,AQ6=\"pass\"),\"C\",IF(AND(AI6=FALSE,AQ6=\"refer\"),\"B\",\"D\")))","v":"A"},null,{"$f":"AJ6+AK6/2","v":0.875},{"$f":"AM6+AN6/2","v":-0.25},{"$f":"MIN((AU6-ABS(AK6/2)),(AV6-ABS(AN6/2)))","v":-0.5},{"$f":"MIN((AU6-ABS(AK6/2)),(AV6-ABS(AN6/2)))","v":-0.5},{"$f":"MAX((AU6+ABS(AK6/2)),(AV6+ABS(AN6/2)))","v":1},{"$f":"ABS((AU6-ABS(AK6/2))-(AV6-ABS(AN6/2)))","v":1.25},{"$f":"MAX(ABS(AK6),ABS(AN6))","v":0.5},{"$f":"MAX(ABS(AK6),ABS(AN6))","v":0.5},{"$f":"MAX(AU6,AV6)","v":0.875},{"$f":"ABS(AU6-AV6)","v":1.125}]
[null,"Device-A",{"$f":"1+C6","v":2},{"$f":"(I7-H7)/365.24","v":{"v":1.0787427444967692,"d":"1.1"}},"m","Wiley","Coyote","2011-12-18","2013-01-15","scm","csm",5,1.25,0.5,95,1.5,0.25,85,{"$f":"M7+N7/2","v":1.5},{"$f":"P7+Q7/2","v":1.625},{"$f":"ABS(S7-T7)","v":0.125},{"$f":"MAX(N7,Q7)","v":{"v":0.5,"d":"0.50"}},{"$f":"MIN((S7-ABS(N7/2)),(T7-ABS(Q7/2)))","v":1.25},{"$f":"MAX((S7+ABS(N7/22)),(T7+ABS(Q7/2)))","v":1.75},{"$f":"ABS((S7-ABS(N7/2))-(T7-ABS(Q7/2)))","v":0.25},{"$f":"IF(D7<4,\"preschool\",\"school\")","v":"preschool"},{"$f":"IF(D7<4,-3,-2)","v":-3},{"$f":"IF(D7<4,3,1.75)","v":3},{"$f":"IF(X7>4,\"T\",\"F\")","v":"F"},{"$f":"IF(Y7>1.25, \"T\",\"F\")","v":"F"},{"$f":"IF(V7>AB7,\"T\",\"F\")","v":"F"},{"$f":"IF(W7<AA7,\"T\",\"F\")","v":"F"},{"$f":"IF(ABS(L7)>8,\"T\",\"F\")","v":"F"},{"$f":"IF(OR(EXACT(\"T\",AC7:AF7)),\"T\",\"F\")","v":"F"},{"$f":"OR(EXACT(\"T\",AC7:AG7))","v":false},1.75,0.5,102,1.25,0.25,106,null,"pass",{"$f":"IF(AND(AH7=\"T\",AQ7=\"refer\"),\"A\",IF(AND(AH7=\"T\",AQ7=\"pass\"),\"C\",IF(AND(AH7=\"F\",AQ7=\"refer\"),\"B\",\"D\")))","v":"D"},{"$f":"IF(AND(AI7=TRUE,AQ7=\"refer\"),\"A\",IF(AND(AI7=TRUE,AQ7=\"pass\"),\"C\",IF(AND(AI7=FALSE,AQ7=\"refer\"),\"B\",\"D\")))","v":"D"},null,{"$f":"AJ7+AK7/2","v":2},{"$f":"AM7+AN7/2","v":1.375},{"$f":"MIN((AU7-ABS(AK7/2)),(AV7-ABS(AN7/2)))","v":1.25},{"$f":"MIN((AU7-ABS(AK7/2)),(AV7-ABS(AN7/2)))","v":1.25},{"$f":"MAX((AU7+ABS(AK7/2)),(AV7+ABS(AN7/2)))","v":2.25},{"$f":"ABS((AU7-ABS(AK7/2))-(AV7-ABS(AN7/2)))","v":0.5},{"$f":"MAX(ABS(AK7),ABS(AN7))","v":0.5},{"$f":"MAX(ABS(AK7),ABS(AN7))","v":0.5},{"$f":"MAX(AU7,AV7)","v":2},{"$f":"ABS(AU7-AV7)","v":0.625}]
[null,"Device-A",{"$f":"1+C7","v":3},{"v":8.944803416931332,"d":"8.9"},"f","Marilyn","Monroe","2003-12-28","2012-12-07",150,100,-5,-5.75,1.5,103,-3.75,1,80,{"$f":"M8+N8/2","v":-5},{"$f":"P8+Q8/2","v":-3.25},{"$f":"ABS(S8-T8)","v":1.75},{"$f":"MAX(N8,Q8)","v":{"v":1.5,"d":"1.50"}},{"$f":"MIN((S8-ABS(N8/2)),(T8-ABS(Q8/2)))","v":-5.75},{"$f":"MAX((S8+ABS(N8/22)),(T8+ABS(Q8/2)))","v":-2.75},{"$f":"ABS((S8-ABS(N8/2))-(T8-ABS(Q8/2)))","v":{"v":2,"d":"2.00"}},{"$f":"IF(D8<4,\"preschool\",\"school\")","v":"school"},{"$f":"IF(D8<4,-3,-2)","v":-2},{"$f":"IF(D8<4,3,1.75)","v":1.75},{"$f":"IF(X8>4,\"T\",\"F\")","v":"F"},{"$f":"IF(Y8>1.25, \"T\",\"F\")","v":"T"},{"$f":"IF(V8>AB8,\"T\",\"F\")","v":"F"},{"$f":"IF(W8<AA8,\"T\",\"F\")","v":"T"},{"$f":"IF(ABS(L8)>8,\"T\",\"F\")","v":"F"},{"$f":"IF(OR(EXACT(\"T\",AC8:AF8)),\"T\",\"F\")","v":"T"},{"$f":"OR(EXACT(\"T\",AC8:AG8))","v":true},1,0,null,-1.5,0.5,87,null,"pass","C","C",null,{"$f":"AJ8+AK8/2","v":1},{"$f":"AM8+AN8/2","v":-1.25},{"$f":"MIN((AU8-ABS(AK8/2)),(AV8-ABS(AN8/2)))","v":-1.5},{"$f":"MIN((AU8-ABS(AK8/2)),(AV8-ABS(AN8/2)))","v":-1.5},{"$f":"MAX((AU8+ABS(AK8/2)),(AV8+ABS(AN8/2)))","v":1},{"$f":"ABS((AU8-ABS(AK8/2))-(AV8-ABS(AN8/2)))","v":2.5},{"$f":"MAX(ABS(AK8),ABS(AN8))","v":0.5},{"$f":"MAX(ABS(AK8),ABS(AN8))","v":0.5},{"$f":"MAX(AU8,AV8)","v":1},{"$f":"ABS(AU8-AV8)","v":2.25}]
[null,"Device-A",4,{"v":2.6201949403132185,"d":"2.6"},"f","Daisey","Duck","2019-01-01","2021-08-15","csm","csm",10,2.25,1,80,2.75,0.75,105,{"$f":"M9+N9/2","v":2.75},{"$f":"P9+Q9/2","v":3.125},{"$f":"ABS(S9-T9)","v":0.375},{"$f":"MAX(N9,Q9)","v":{"v":1,"d":"1.00"}},{"$f":"MIN((S9-ABS(N9/2)),(T9-ABS(Q9/2)))","v":2.25},{"$f":"MAX((S9+ABS(N9/22)),(T9+ABS(Q9/2)))","v":{"v":3.5,"d":"3.50"}},{"$f":"ABS((S9-ABS(N9/2))-(T9-ABS(Q9/2)))","v":{"v":0.5,"d":"0.50"}},{"$f":"IF(D9<4,\"preschool\",\"school\")","v":"preschool"},{"$f":"IF(D9<4,-3,-2)","v":-3},{"$f":"IF(D9<4,3,1.75)","v":3},{"$f":"IF(X9>4,\"T\",\"F\")","v":"F"},{"$f":"IF(Y9>1.25, \"T\",\"F\")","v":"F"},{"$f":"IF(V9>AB9,\"T\",\"F\")","v":"F"},{"$f":"IF(W9<AA9,\"T\",\"F\")","v":"F"},{"$f":"IF(ABS(L9)>8,\"T\",\"F\")","v":"T"},{"$f":"IF(OR(EXACT(\"T\",AC9:AF9)),\"T\",\"F\")","v":"F"},{"$f":"OR(EXACT(\"T\",AC9:AG9))","v":true},1,1,90,1.25,1.25,100,"r","refer","B","A",null,{"$f":"AJ9+AK9/2","v":1.5},{"$f":"AM9+AN9/2","v":1.875},{"$f":"MIN((AU9-ABS(AK9/2)),(AV9-ABS(AN9/2)))","v":1},{"$f":"MIN((AU9-ABS(AK9/2)),(AV9-ABS(AN9/2)))","v":1},{"$f":"MAX((AU9+ABS(AK9/2)),(AV9+ABS(AN9/2)))","v":2.5},{"$f":"ABS((AU9-ABS(AK9/2))-(AV9-ABS(AN9/2)))","v":0.25},{"$f":"MAX(ABS(AK9),ABS(AN9))","v":1.25},{"$f":"MAX(ABS(AK9),ABS(AN9))","v":1.25},{"$f":"MAX(AU9,AV9)","v":1.875},{"$f":"ABS(AU9-AV9)","v":0.375}]
["Add more rows here -->","Device-A",5,{"v":0,"d":"0.0"},{"$nulls":14},0,0,0,{"v":0,"d":"0.00"},{"$f":"MIN((S10-ABS(N10/2)),(T10-ABS(Q10/2)))","v":0},{"$f":"MAX((S10+ABS(N10/22)),(T10+ABS(Q10/2)))","v":{"v":0,"d":"0.00"}},{"$f":"ABS((S10-ABS(N10/2))-(T10-ABS(Q10/2)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(D10<4,\"preschool\",\"school\")","v":"preschool"},{"$f":"IF(D10<4,-3,-2)","v":-3},{"$f":"IF(D10<4,3,1.75)","v":3},{"$f":"IF(X10>4,\"T\",\"F\")","v":"F"},{"$f":"IF(Y10>1.25, \"T\",\"F\")","v":"F"},{"$f":"IF(V10>AB10,\"T\",\"F\")","v":"F"},{"$f":"IF(W10<AA10,\"T\",\"F\")","v":"F"},{"$f":"IF(ABS(L10)>8,\"T\",\"F\")","v":"F"},{"$f":"IF(OR(EXACT(\"T\",AC10:AF10)),\"T\",\"F\")","v":"F"},{"$f":"OR(EXACT(\"T\",AC10:AG10))","v":false},{"$nulls":8},"D","D",null,0,0,0,0,0,0,0,0,0,0]
[null,"Device-A","last",{"$nulls":22},{"$f":"IF(D11<4,\"preschool\",\"school\")","v":"preschool"},{"$f":"IF(D11<4,-3,-2)","v":-3},{"$f":"IF(D11<4,3,1.75)","v":3},{"$f":"IF(X11>4,\"T\",\"F\")","v":"F"},{"$f":"IF(Y11>1.25, \"T\",\"F\")","v":"F"},{"$f":"IF(V11>AB11,\"T\",\"F\")","v":"F"},{"$f":"IF(W11<AA11,\"T\",\"F\")","v":"F"},{"$f":"IF(ABS(L11)>8,\"T\",\"F\")","v":"F"},{"$f":"IF(OR(EXACT(\"T\",AC11:AF11)),\"T\",\"F\")","v":"F"},{"$f":"OR(EXACT(\"T\",AC11:AG11))","v":false},{"$nulls":8},"D","D"]
{"$rows_empty":10}
[{"$nulls":33},"Exam-True","Exam-False",{"$nulls":7},"A",{"$f":"COUNTIF(AR6:AR11,\"A\")","v":1},{"$f":"COUNTIF(AS6:AS11,\"A\")","v":2}]
[{"$nulls":32},"screen+","A","B",{"$nulls":7},"B",{"$f":"COUNTIF(AR6:AR11,\"B\")","v":1},{"$f":"COUNTIF(AS6:AS11,\"B\")","v":0}]
[{"$nulls":32},"screen-","C","D",{"$nulls":7},"C",{"$f":"COUNTIF(AR6:AR11,\"C\")","v":1},{"$f":"COUNTIF(AS6:AS11,\"C\")","v":1}]
[{"$nulls":32},"screen-i","E ","F","inconclusive",{"$nulls":6},"D",{"$f":"COUNTIF(AR6:AR11,\"D\")","v":3},{"$f":"COUNTIF(AS6:AS11,\"D\")","v":3}]
[{"$nulls":41},"ARF:",null,"refractive","ref + strab"]
[{"$nulls":40},"Sensitivity",null,null,{"$f":"AR22/(AR22+AR24)","v":{"v":0.5,"d":"50%"}},{"$f":"AS22/(AS22+AS24)","v":{"v":0.6666666666666666,"d":"67%"}},"A/(A+C)"]
[{"$nulls":40},"Specificity",null,null,{"$f":"AR25/(AR23+AR25)","v":{"v":0.75,"d":"75%"}},{"$f":"AS25/(AS23+AS25)","v":{"v":1,"d":"100%"}},"D/(D+B)"]
[{"$nulls":40},"PPV",null,null,{"$f":"AR22/(AR22+AR23)","v":{"v":0.5,"d":"50%"}},{"$f":"AS22/(AS22+AS23)","v":{"v":1,"d":"100%"}},"A/(A+B)"]
[]
[{"$nulls":40},"ROC curve builder",null,null,"1-specificity","sensitivty"]
[{"$nulls":40},"Refractive",null,"R",{"$f":"1-AR28","v":{"v":0.25,"d":"25%"}},{"$f":"AR27","v":{"v":0.5,"d":"50%"}}]
[{"$nulls":40},"Strab + refractive",null,"S+R",{"$f":"1-AS28","v":{"v":0,"d":"0%"}},{"$f":"AS27","v":{"v":0.6666666666666666,"d":"67%"}}]